package com.hqyj.bigdata_project.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hqyj.bigdata_project.entity.CatalogVideoTopTenInfo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface CatalogVideoTopTenMapper extends BaseMapper<CatalogVideoTopTenInfo> {

    @Select("select distinct (categoryName) from catalogvideotopteninfo")
    public List<String> queryDistinctCatalogList();

    @Select("select views from catalogvideotopteninfo where categoryName = #{catalogName} and flag = 0;")
    public List<Integer> queryVideoViewsListByCatalogName(String catalogName);
}
